package cn.bgs.mapper;

import cn.bgs.pojo.Complaints;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ComplainMapper {
    List<Complaints> selectAll(Integer complaintsTypeId);

    @Select("SELECT complaints_type_id,type FROM community_usermanagement.complaints_type")
    @Results(
            {@Result(property = "complaintsTypeId", column = "complaints_type_id"),
                    @Result(property = "type", column = "type")})
    List<Complaints> tousuSelect();
}
